DelFiles

A very simple to delete a directory and the entire files and folders in its ...

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

ProtectFile_XorD + UnProtectFile_XorD

Protects and unprotects a file using password Creates another copy of the file ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

ANmaRedirect_Plus1

Function to log the redirects that happen into website It is merely used with ...

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

ConvertImage_IrfanView

Converts an image from any image into any image using IrfanView command line ...

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip